Insider's Guide to Microsoft Excel 2013 by Brian West

Author:Brian West [West, Brian]
Language: eng
Format: epub, azw3
Publisher: UNKNOWN
Published: 2016-11-05T07:00:00+00:00

In the image below, I have put red and green boxes around the two buttons that deal with decimal places. The left button (with the red box) will increase the number of decimal places by 1, each time it is pressed. So, if I were to press it now, 17.00 would become 17.000… Mathematically, it’s still the same to Excel. Pressing the right button will decrease by 1. Since I pressed the red button once, I can press the green one three times to get my numbers to have 0 decimal places.

Functions vs Formulas

Ok everybody. Until now, I have showed you how to enter your formulas manually. This was necessary so you could see how they work and so you could understand what was going on in a formula… I showed you how you could type the equal sign = and then add, subtract, multiply and divide

We have already used some very basic formulas. For example, we used the formula

= D5 + D6 + D7 + D8 + D9 +D10 + D11 + D12 + D13 + D14 + D15

This added the values in all of the cells from D5 through D15… We wrote this formula ourselves…

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.